import pandas as pd
import numpy as np

# 报文
df1 = pd.read_excel("resources/报文-字段对比-完整版.xlsx",sheet_name='Sheet1')
df1_dict = dict(zip(df1['CSTP域号(报文)'],df1['序号']))

# 字段
df2 = pd.read_excel("resources/报文-字段对比-完整版.xlsx",sheet_name='Sheet2')
df2_dict = dict(zip(df2['IMIX2.0域号(映射)'],df2['序号']))
# print(df2_dict)

# 查找字段对应报文
# for i in df2_dict.keys():
#     print(df1_dict[i])

# for i in df1_dict.keys():
#     if(i in df2_dict.keys()):
#         print(df2_dict[i])
#     else:
#         print(44)


df3 = pd.read_excel("resources/CCS字段映射.xlsx",sheet_name='Sheet1',index_col='IMIX2.0域号')
print(df3.loc[11460])